/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-22 23:53:44
*/


-- ----------------------------
-- Table structure for tb0199
-- ----------------------------
DROP TABLE [dbo].[tb0199]
GO
CREATE TABLE [dbo].[tb0199] (
[ID] int IDENTITY(1,1) NOT NULL,
[DivisionID] varchar(20) NOT NULL ,
[TranMonth] int NOT NULL ,
[TranYear] int NOT NULL ,
[Closing] tinyint NOT NULL DEFAULT ((0)) ,
[BeginDate] datetime NULL ,
[EndDate] datetime NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[Active] int NOT NULL DEFAULT ((0)),
[GroupShow] varchar(150) NOT NULL DEFAULT ((''))
)


GO

-- ----------------------------
-- Indexes structure for table tb0199
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0199
-- ----------------------------
ALTER TABLE [dbo].[tb0199] ADD PRIMARY KEY NONCLUSTERED ([DivisionID], [TranMonth], [TranYear])
GO
